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)