Oracle Database Discussions

Hello,

When the column stores only Yes / No Values. What is the right definition for that column. Is the following right pertaining IS_PAID column :

CREATE TABLE ABSENCE
  (
    ID         NUMBER (3) NOT NULL ,
    USER_ID    NUMBER (3) NOT NULL ,
    IS_PAID    VARCHAR2 (1 BYTE) DEFAULT 'N' NOT NULL ,
   .......
.....
  ) ;
 
ALTER TABLE ABSENCE ADD CHECK
(
  IS_PAID IN ('N', 'Y')
)
;

Regards,