test
Tables (10)
CODE_SUB
- CODE_SUB_ID — varchar(20) — Primary key — NOT NULL
- modDate — datetime
- regDate — datetime
- CODE_SUB_EXPLAIN — varchar(100)
- CODE_SUB_NAME — varchar(20)
CODE_SUPER
- CODE_SUPER_ID — varchar(255) — Primary key — NOT NULL
- modDate — datetime
- regDate — datetime
- CODE_SUPER_EXPLAIN — varchar(100)
- CODE_SUPER_NAME — varchar(20) — NOT NULL
FAQ
- ID — bigint(20) — Primary key — NOT NULL
- modDate — datetime
- regDate — datetime
- FAQ_CONTENT — text — NOT NULL
- FAQ_TITLE — varchar(200) — NOT NULL
FILE
- ID — bigint(20) — Primary key — NOT NULL
- modDate — datetime
- regDate — datetime
- FILE_EXTENSION — varchar(10) — NOT NULL
- FILE_NAME — varchar(200) — NOT NULL
- FILE_ORIGINAL_NAME — varchar(200) — NOT NULL
- FILE_PATH — varchar(200) — NOT NULL
- FILE_SAVE_PATH — varchar(200) — NOT NULL
- FILE_TYPE — varchar(10) — NOT NULL
- FILE_FAQ — bigint(20) — Foreign key → FAQ.ID
- FILE_NOTICE — bigint(20) — Foreign key → NOTICE.ID
- FILE_SCHEDULE — bigint(20) — Foreign key → SCHEDULE.ID
- FILE_MEMBER — varchar(100) — Foreign key
NOTICE
- ID — bigint(20) — Primary key — NOT NULL
- modDate — datetime
- regDate — datetime
- NOTICE_CONTENT — text — NOT NULL
- NOTICE_TITLE — varchar(200) — NOT NULL
SCHEDULE
- ID — bigint(20) — Primary key — NOT NULL
- modDate — datetime
- regDate — datetime
- SCHEDULE_ALL_TIME_YN — bit(1) — NOT NULL
- SCHEDULE_DDAY_YN — bit(1) — NOT NULL
- SCHEDULE_LUNAR_YN — bit(1) — NOT NULL
- SCHEDULE_REPEAT_YN — bit(1) — NOT NULL
- SCHEDULE_REPEAT_MONTH — bigint(20)
- SCHEDULE_REPEAT_WEEK — varchar(255)
- SCHEDULE_REPEAT_YEAR — varchar(5)
- SCHEDULE_SCHEDULE_START_DATE — datetime — NOT NULL
- SCHEDULE_REPEAT_END_DATE — datetime
- SCHEDULE_TITLE — varchar(100) — NOT NULL
- SCHEDULE_USER_INFO — text — NOT NULL
- SCHEDULE_MEMBER — varchar(100) — Foreign key — NOT NULL
- SCHEDULE_CONTENT — text
- SCHEDULE_COLOR — varchar(50) — NOT NULL
- SCHEDULE_ALARM_YN — bit(1) — NOT NULL
- SCHEDULE_DDAY_DDAY1_YN — bit(1) — NOT NULL
- SCHEDULE_DDAY_DDAY2_YN — bit(1) — NOT NULL
- SCHEDULE_DDAY_DDAY3_YN — bit(1) — NOT NULL
- SCHEDULE_DDAY_DDAY_YN — bit(1) — NOT NULL
- SCHEDULE_DDAY_MDAY1_YN — bit(1) — NOT NULL
- SCHEDULE_DDAY_TIME — varchar(255)
- SCHEDULE_DDAY_YDAY1_YN — bit(1) — NOT NULL
- SCHEDULE_DDAY_YDAY2_YN — bit(1) — NOT NULL
- SCHEDULE_DDAY_YDAY3_YN — bit(1) — NOT NULL
- SCHEDULE_SHARE_YN — bit(1) — NOT NULL
SCHEDULE_ALARM_TYPE
- ID — bigint(20) — Primary key — NOT NULL
- modDate — datetime
- regDate — datetime
- SCHEDULE_ALARM_TYPE_SCHEDULE — bigint(20) — Foreign key → SCHEDULE.ID — NOT NULL
SCHEDULE_GOOD
- ID — bigint(20) — Primary key — NOT NULL
- modDate — datetime
- regDate — datetime
- SCHEDULE_GOOD_MEMBER — varchar(100) — Foreign key — NOT NULL
- SCHEDULE_GOOD_SCHEDULE — bigint(20) — Foreign key → SCHEDULE.ID — NOT NULL
SCHEDULE_REPLY
- ID — bigint(20) — Primary key — NOT NULL
- modDate — datetime
- regDate — datetime
- SCHEDULE_REPLY_CONTENT — text
- SCHEDULE_REPLY_MEMBER — varchar(100) — Foreign key — NOT NULL
- SCHEDULE_REPLY_SCHEDULE — bigint(20) — Foreign key → SCHEDULE.ID — NOT NULL
SCHEDULE_TYPE
- ID — bigint(20) — Primary key — NOT NULL
- modDate — datetime
- regDate — datetime
- SCHEDULE_TYPE_SCHEDULE — bigint(20) — Foreign key → SCHEDULE.ID — NOT NULL