homepage
Tables (12)
C
- sec_no — int — Primary key
- sec_type — varchar2
- fst_num — int — Foreign key → STUDY.fst_no — NOT NULL
CBOARD (CBoard)
- value — varchar2
- sec_no — int — Foreign key → C.sec_no
CODE (Code)
- c_id — int — Primary key — NOT NULL
- c_type — varchar2
- m_id — int — Foreign key → MAIN.m_id — NOT NULL
COOK (Cook)
- fst_no — int — Primary key — NOT NULL
- fst_type — varchar2
- c_id — int — Foreign key → CODE.c_id — NOT NULL
JAVA (Java)
- sec_no — int — Primary key
- sec_type — varchar2
- fst_num — int — Foreign key → STUDY.fst_no — NOT NULL
JAVABOARD (JavaBoard)
- value — varchar2
- sec_no — int — Foreign key → JAVA.sec_no
MAIN (Main)
- m_id — int — Primary key — NOT NULL
SQL (Sql)
- sec_no — int — Primary key
- sec_type — varchar2
- fst_num — int — Foreign key → STUDY.fst_no — NOT NULL
SQLBOARD (SqlBoard)
- value — varchar2
- sec_no — int — Foreign key → SQL.sec_no
STATUS (Stat)
- update_date — date
- rnk_date — date
- u_rnk — int
- in_date — date
- out_date — date
- p_number_1 — int
- p_number_2 — int
- p_number_3 — int
- u_pw — varchar2
- u_no — int — Foreign key → USER.u_no
STUDY (Study)
- fst_no — int — Primary key — NOT NULL
- fst_type — varchar2 — NOT NULL
- c_id — int — Foreign key → CODE.c_id — NOT NULL
USER (User)
- u_no — int — Primary key
- u_id — varchar2 — NOT NULL
- u_nm — varchar2
- u_age — int
- u_ssn — int
- u_sex — varchar2
- c_id — int — Foreign key → CODE.c_id — NOT NULL