memory card
Tables (5)
CARD (암기 카드)
- Key (CARD_ID) — NUMBER(19,0) — Primary key — NOT NULL
- Key (CATEGORY_ID) — NUMBER(19,0) — Foreign key → CATEGORY.Key — NOT NULL
- Key (MEMBER_ID) — NUMBER(19,0) — Foreign key → MEMBER.Key — NOT NULL
- Field (TITLE) — VARCHAR2(120 CHAR) — NOT NULL
- Field (IMAGES) — VARCHAR2(1020 CHAR)
- Field (OX_ANSWER) — VARCHAR2(2 CHAR) — O, X 만 입력 가능
- Field (MULTI_CHOICE_ANSWER) — NUMBER(10,0) — 1 ~ 5
- Field (KEYWORD_ANSWER) — VARCHAR2(255 CHAR)
- Field (ESSAY_ANSWER) — VARCHAR2(2000 CHAR)
- Field (QUESTION) — CLOB — NOT NULL
- Field (DESCRIPTION) — CLOB — length: < 2,1000
- Field (CREATED_AT) — TIMESTAMP(6)
- Field (MODIFIED_AT) — TIMESTAMP(6)
- Field (IS_DELETED) — NUMBER(1,0)
- Field (DTYPE) — VARCHAR2(31 CHAR)
CARD_HISTORY (암기카드 히스토리)
- Key (CARD_HISTORY_ID) — NUMBER(19,0) — Primary key — NOT NULL
- Key (CARD_ID) — NUMBER(19,0) — Foreign key → CARD.Key — NOT NULL
- Field (CARD_ANSWER) — VARCHAR2(2000 CHAR)
- Field (CARD_TYPE) — VARCHAR2(255 CHAR)
- Field (CARD_CREATED_AT) — TIMESTAMP(6)
- Field (CARD_DESCRIPTION) — CLOB
- Field (CARD_MEMBER_ID) — NUMBER(19,0)
- Field (CARD_MODIFIED_AT) — TIMESTAMP(6)
- Field (CARD_QUESTION) — CLOB
- Field (CARD_TITLE) — VARCHAR2(120 CHAR)
- Field (CREATED_AT) — TIMESTAMP(6)
- Field2 (IS_DELETED) — NUMBER(1,0)
- Field3 (SCORE) — NUMBER(10,0)
- Field (SOLVED_USER_ID) — NUMBER(19,0)
- Field (USER_ANSWER) — VARCHAR2(2000)
CATEGORY (카드 카테고리)
- Key (CATEGORY_ID) — NUMBER(19,0) — Primary key — NOT NULL
- Key (MEMBER_ID) — NUMBER(19,0) — Foreign key → MEMBER.Key — NOT NULL
- Field (TITLE) — VARCHAR2(120 CHAR) — NOT NULL — length: < 40 not blank
- Field (CREATED_AT) — TIMESTAMP(6)
- Field (MODIFIED_AT) — TIMESTAMP(6)
- Field (IS_DELETED) — NUMBER(1,0) — NOT NULL
- Field (IS_SHARED) — NUMBER(1,0) — NOT NULL
- Field (THUMBNAIL) — VARCHAR2(255 CHAR)
CATEGORY_RECOMMEND (카테고리 추천)
- Key (CATEGORY_RECOMMEND_ID) — NUMBER(19,0) — Primary key — NOT NULL
- Key (RECOMMEND__MEMBER_ID) — NUMBER(19,0) — Foreign key → MEMBER.Key — NOT NULL
- Key (CATEGORY_ID) — NUMBER(19,0) — Foreign key → CATEGORY.Key — NOT NULL
- Field (CREATED_AT) — TIMESTAMP(6)
- Field (MODIFIED_AT) — TIMESTAMP(6)
- Field (IS_DELETED) — NUMBER(1,0)
MEMBER (회원)
- Key (MEMBER_ID) — NUMBER(19,0) — Primary key — NOT NULL
- Field (EMAIL) — VARCHAR2(255 CHAR) — NOT NULL — "^[\\w-.]+@([\\w-]+\\.)+[\\w-]{2,4}$"
- Field (OAUTH_ID) — VARCHAR2(255 CHAR)
- Field (NAME) — VARCHAR2(60 CHAR) — NOT NULL — length: 1 ~ 20 not blank
- Field (PROFILE) — VARCHAR2(255 CHAR)
- Field (O_AUTH_TYPE) — VARCHAR2(10 CHAR)
- Field (ROLE) — VARCHAR2(10 CHAR)
- Field (CREATED_AT) — TIMESTAMP(6)
- Field (MODIFIED_AT) — TIMESTAMP(6)
- Field (IS_DELETED) — NUMBER(1,0)